Helpful Information

Category: Databases

Command-line syntax for "create table"

OS=Linux
DB=Mysql

Did it once, but discarded notes, so asking someone.

Question: Command-line syntax to create table from a schema file.

Ex: $mysql -u dave -p somedb schema.tablename<cr>

I know this is wrong, but not too far off. Correct syntax appreciated.

Thanks in Advance,

Dave

$mysql -u dave -p somedb < schema.tablename<cr>

should do the job.

<BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">quote:</font><HR>Originally posted by chyrag:
$mysql -u dave -p somedb < schema.tablename<cr>

should do the job.[/quote]

It worked. Thanks. It's time to write it down and save this time.

Dave